Macro to Convert Columns of Data Across Into Rows Down

[adamzee]

Hi,
I have some payroll information that goes across columns which includes information such as hours and kms. I require a macro to extract the information from the columns such as hours, kms and the job performed and place on a new worksheet going down.
The amount of columns across is dynamic and may be in the 100 of columns across. This varies month to month. If there is no data in both Kms and hours for that particular person and that particular job then no information is transferred over for that person in the new worksheet. I have included an example file which shows on the second tab the output I hope to get from the macro. examplepayroll.xlsx

Thanks

[nilem]

Hi adamzee,
try this

Please Login or Register  to view this content.

[MarvinP]

Hi Adam,

I've use a macro many times to convert a Cross Tab table to a better Excel type table. See if example gets you closer to what you need.

[adamzee]

Thanks Nilem and MarvinP, both great solutions!