Transpose

[chiragpatel_1]

Hello All,

Bit of a dilemma, it'a week of dilemma tbh.

I have attached a sample data set. Columns A-I contains information i.e text and there are periods (financial) Column J onward and under each of those columns contain numbers. This is the layout that my real data set has.

What I want to do is kind of rejig the data so that all the periods appear under one column, so I can call that new column, 'period', while making sure information from columns A-I correlates to each of those periods as they did in the original format.

Is there any convoluted way to do this.

Any help will be much appreciated.

[davidskaife]

Hi @chiragpatel_1 

Something like the attached?