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.
