Hi wondering if someome might be able to point me in the right direction, i have a spreadsheet with massive amounts of data (circa 8000 lines) the issue is that of those 8000, there is a group of 9 lines that need the data from various columns across those rows merged into a single row.
for example when i filter a result for a single item, i have 9 rows of it, in several columns i have different values, staggered across those rows and i’d like to try and tidy it up by having only one row with all the data showing in its appropriate column. so for example it looks like this:
and i’m trying to get it to look like this:
wondering if anyone had some advice on what i can do to speed this process up,instead of manually doing it
i hope my message makes sense
thanks in advance
