Data Layout Problem

[Ronit_Gupta]

Excel sheet has tables with same columns but with different merge formats. Need to have all the tables in one data set and make pivot out of that for further analysis.

[aatalai]

@Ronit_Gupta this should do the trick, let me know how you get on 

[Ronit_Gupta]

Data is still in different columns.  All tables have same columns but merging is different. How to solve it?

Machine

Aplus Losstime Group

Aplus Code

Aplus Description

Code

Code Description

Loss Time (h)

Loss Time (#)

(h) / (#)

[aatalai · Accepted solution]

ah ok this should resolve it