Stacking Coordinates into a list

J

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: 12
  • List.png
    List.png
    69.8 KB · Views: 11

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
You must log in or register to reply here.

Similar threads

M
  • Question
VBA Code to Create Named Ranges for Entire Columns in a Worksheet Based on a List of Names in Another Worksheet
Replies
3
Views
607
Norie
Norie
S
  • Question
Exel Custom UI Expand all groups
Replies
0
Views
954
Serafin54
S
M
  • Question
Struggling with Variants within my data
Replies
1
Views
400
Mr Young
M
L
  • Question
Converting data from matrix to list format
Replies
7
Views
14K
Anigito
Anigito
N
  • Question
Join data from second worksheet with delimited list values (mults) to another worksheet with one value per cell/row and keep 1:1 relationship
Replies
2
Views
1K
HeadAgainstABrickWall
H

Forum statistics

Threads
1,215,014
Messages
6,122,697
Members
449,092
Latest member
snoom82

Share this page

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