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