Hi all,
I was wondering if it is possible to transpose data in rows, where each entry is separated by the same line of text. The problem for me is that each data entry contains different amount of rows for each company so cannot simply separate at every e.g. 6th row... Therefore, I need a macro that can recognize the standard line of text as a que for a new transposition. There is no spacing between the rows.
My data looks like this:
company name
address
phone
email
web
STANDARD LINE OF TEXT ("Biotech therapeutics")
I hope someone can help
I was wondering if it is possible to transpose data in rows, where each entry is separated by the same line of text. The problem for me is that each data entry contains different amount of rows for each company so cannot simply separate at every e.g. 6th row... Therefore, I need a macro that can recognize the standard line of text as a que for a new transposition. There is no spacing between the rows.
My data looks like this:
company name
address
phone
web
STANDARD LINE OF TEXT ("Biotech therapeutics")
I hope someone can help
