Stacking Coordinates into a list

JungleOates

New Member
Joined
May 19, 2022
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hi.

I would really appreciate some help with this, ive been wasting so much time on a task I know can be automated but have no idea where to start.

I need to stack sets of two columns into a list.

I need to convert the database into this format for a old school numerical modeling tool.

I need the dataset label to remain as a separator (I will change dataset to P when complete) and each dataset has an varying number of points

There can be up to 800 of these individual data sets so manually copying these is destroying my will to live.

Please Help!
 

Attachments

  • Dataset.png
    Dataset.png
    88.8 KB · Views: 23
  • List.png
    List.png
    69.8 KB · Views: 29

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Forum statistics

Threads
1,224,813
Messages
6,181,107
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top