I've just pulled some data from a website using excel and now I'd like to sort it.
Each product contains 3 rows of information, which I would need to keep together when sorting. The following is an example:
Product 1 Rec Sale Price £2 Rec Buy Price £1 Product Category Rec Exchange Price £1.50 Product 2 Rec Sale Price £3 Rec Buy Price £2 Product Category Rec Exchange Price £2.50
Note - Where it says 'product category', that has come with the information I've taken but it is unnecessary and I don't need it.
I'd quite happily have all the info in one row like so:
Title Sale Price Buy Price Ex Price P1 £3 £2 £2.50
However, there's almost 3000 rows and so I've no idea how to sort it without editing each row individually.
I've thought it's perhaps possible to lock every 3 rows together and then sort - but could I have excel repeat the process for the remaining rows?
I've even thought it maybe possible to somehow copy and paste the product name into the 2 rows below so that the product name is in each of the 3 rows, then at least that way, I could sort the info. Again, would it be possible for excel to replicate my action?
My preferred choice would be to have all the info in 1 row (as illustrated above) but is there anyway I could get excel to do it for me without me having to painstakingly do it myself?