Hello dear community,
I've been facing an issue for a couple of days and a friend of mine advised me to register on Excel Forum and post my question here. So in every case thanks for any help which will be greatly appreciated!
I received a database for which the hierarchy between cells is indicated by the level of indent (see below):
Capture1.JPG
When I run a pivot table on this table I lose all hierarchy, hence I would like to format it this way:
Capture2.JPG
As I have ~3,000 rows to reformat I'm looking for an easy/automated solution. Can someone help?
Thanks again for the help,
T. Olbrechts
Bookmarks