Splitting data

[Daz2424]

Hello

I believe this is a simple question but I am struggling to split data.

I have a list of different contracts and then have data relating to column A, B, C etc and would like to split the data so that is adds the contract and value in A and then adds underneath the same contract number with the value in B etc.

The attachment shows how the data is currently.

Thank you in advance!

[Emil_Kos]

Hi @Daz2424,

I think you forgot to add an attachment. 

[Daz2424]

thank you for letting me know. I have now added the table below:

Kind regards

Daz

[grazitti_sapna]

Hi @Daz2424 , is this what you are trying to achieve?

Final Output

Thanks.

[Daz2424]

thank you. It is more to come out like this with a separate row for each value even if the leading number is the same:

[seven · Accepted solution]

Hi,

this isn't what I would call "splitting" data at all. In any case, this simple workflow will do the job for you.

[Daz2424]

Perfect thank you for your help!

I was not sure what else to call it ;-))

[seven · Accepted solution]

@Daz2424 

please mark my post as a solution, thank you.