Re-arranging data

[yorkuvir]

Hello folks,

https://ibb.co/kZZ2Qv

As in the above figure, I have a worksheet containing rows that looks like the left side of the figure, and I wish to sort them out to look like the right side of the figure. Please note, the Goods referred to in the subsequent rows are different, say, apples and oranges respectively, so I cannot merge them or apply filters to them.

What is the shortest way I can accomplish this?

Thanks.

 

[mole999]

you may not get many takers for that file, I certainly don't recognise the hyperlink as a regular global cloud, and in modern times with ransomware abounding I won't visit. I know you will understand

 

[yorkuvir]

You can trust that site because Google trusts it. When I search for 'free image hosting' that is the first site I get in google right now.

 

[yorkuvir]

Or, if you want me to upload to some specific site, I can do that too, just mention that 'trusted' site. Thanks.

 

[mole999]

i don't use cloud service often, I know dropbox and the like (thats not a recommendation) > is ibb.co a scam or legit | ibb.co trust reviews |check ibb.co for fraud and risk | is ibb.co safe or fake, as you will see it does redirect to another site, and ownership is not exposed. It maybe more reliable than other sites, all i am saying is I express caution when the unknown occurs

 

[yorkuvir]

is ibb.co a scam or legit | ibb.co trust reviews |check ibb.co for fraud and risk | is ibb.co safe or fake says "High Trust Rating. This Site Looks Safe To Use."

So, what do you want me to do?

I can either upload either a picture or a spreadsheet. Thanks.

 

[mole999]

choice is yours, picture, html tables, no on can add spreedsheets, a globally known sharing site

 

[yorkuvir]

Alternate location: https://prnt.sc/fcn6ls

 

[Rick Rothstein]

What columns are your data in?

What row does it start on?

Where do you want the output to go to?

 

[yorkuvir]

Sorry, I just mentioned left and right sides of the figure earlier. Here is the new screenshot: https://prnt.sc/fcnyhz .

My data is from c4 to d24 .

I wish the result to go into g4 to i11 OR from g5 to i11, because g4, h4 and i4 can be manually entered too.

B5, B6, c3, d3, h3 and i3 are just extra entries for clarification.

Thanks.