I a need to transpose a variable data set that is that is in 4 columns to 2 rows with a emty column between every column with data.
I think a macro would be the beter way forward rather than with a IF Statement. Unfortunately I am novice when it comes to coding
macros and would really appreciate any help.
Below is a sample of the data in one sheet
No, Aquifer 1 , Aquifer 2 , Aquifer 3
1 , Unconfined, Confined ,
2 , Unconfined, Confined , Uncertain
3 , Unconfined,
4 , Unconfined, Unconfined,
5 , Unconfined, Unconfined, Unconfined
It must be in the following format on another sheet:
No 1 , , 1 , , 2 , , 2 , , 2 , , 3 , ,
Unconfined, ,Confined, ,Unconfined, ,Confined, ,Uncertain, ,Unconfined, ,
I have also attached a xlsx file
Thank you in advance for any input.