Rearrange data format

[tpcbrap]

Hi,

I recieve the data from the machine in the format shown on the left of the image.

I’m trying to take the list from being all in one column to being separated into columns with by Tomato Number.

Column A should be in ascending order for each Tomato No.

Is there any function that could do this automatically ?

Usually I’d just copy + paste C8:C13 into L2 and C14:C19 into M2 but this takes forever with large data sets.

Any help would be very much appreciated.

Cheers

Screen Shot 2018-02-21 at 15.57.54.png

[tpcbrap]

Just to clarify columns should be named differently

K1= Tomato 1

L1 = Tomato 2

M1 = Tomato 3

[daboho]

Please Login or Register  to view this content.