Hi I have data organised in 1 column in this way:
acc1
acc2
tr1 (summary line)
acc1
acc4
acc5
acc6
tr2 (summary line)
acc2
acc3
tr3 (summary line)
There always is a summary line after group of "acc". However there always is different counts of "acc". The data is downloaded from another application so I can't work with the groups or subtotals. It's raw data.
And I want to get it shaped into 2 columns like this:
tr1; acc1
tr1; acc2
tr1; tr1 (summary line)
tr2; acc1
tr2; acc4
tr2; acc5
tr2; acc6
tr2; tr2 (summary line)
tr3; acc2
tr3; acc3
tr3; tr3 (summary line)
...so that the 'summary title' is sitting in the cell left to 'acc' for each 'acc'.
I would like to avoid filter and copy-paste and fill. I would like to have one easy formula or one easy step.
Is there some easy step how to do it?
Thank you.
Bookmarks