Linked Questions

0
votes
1answer
1k views

Create multiple rows based on repeated columns [duplicate]

I have a csv (technically, an Excel spreadsheet) that has rows/columns like this: AC-10 ECLO-1 ECLO-2 AC-11 PESL-1 AC-13 ABCD-2 ABDE-3 AGTU-5 What I'd like to do is create two columns so ...
0
votes
4answers
331 views

Splitting a row with one company in a column and multiple email addresses in other columns [duplicate]

I have data in Excel that looks like this: column1 column2 column3, column4, column5 Company1 email1 email2 email3 Company2 email1 email2 Company3 email1 email2 email3 email4 email5 I have about 25k ...
0
votes
0answers
88 views

How can I split cells to a new row? [duplicate]

I have products in a spreadsheet in which some have multiple categories. I need to split those categories in to a new row with the same product information. For example, I have the following: Product ...
0
votes
0answers
47 views

Transposing data from multiple columns to rows with preceding data [duplicate]

Wasn't sure how to title this, but I have data in multiple columns after doing a Text-to-column process. I need the first few columns (fields) copied to a new row for each one of the newly created ...
4
votes
1answer
8k views

Turn one row into multiple rows in Excel

I have multiple items that are available in multiple distribution centers (i.e., a many-to-many relationship). There is currently one row per item, with one column for each distribution center. A cell ...
2
votes
1answer
2k views

How can I split Excel data from one row into multiple rows

Good afternoon, Is there a way to split data from one row and store to separate rows? I have a large file that contains scheduling information and I'm trying to develop a list that comprises each ...
1
vote
1answer
1k views

How to convert one row of data into multiple rows in Excel

How do I take one row of data in Excel and split it into multiple rows? Given this input: Name Award Type 1 Amount 1 Award Type 2 Amount 2 Dan Top Performer $5,000 Top ...
1
vote
2answers
2k views

Creating multiple rows from one row of Excel Data

My data looks like this: Parameter Location_A Location_B Location_C Location_D A 1 0.3 0.2 0.1 B 0.9 0.3 0.1 0.1 C ...
1
vote
1answer
684 views

Many to many relationship: convert one row to m×n rows [closed]

I'm not sure how to explain this, but I have two columns that have multiple data words in each cell per column (Notional Data) that need to be combined, but separately. Column A ...
1
vote
0answers
276 views

Excel: sliding range lookup

Sorry my excel is a bit rusty. I am trying to do a manual merging with a vlookup on a table that contains several time series. Example A B C D 1 Date1 V1 Date2 V2 2 ...
1
vote
1answer
106 views

Merge columns into single one based on ID

In Excel, how can I merge multiple columns into single one (i.e., split one row into multiple rows) based on ID? The image below illustrates what I want to do. ID and Catalog Code are unique but ...
0
votes
2answers
52 views

In Excel - split a row into multiple rows

I would like an Excel formula that will help me split entries in a single row to be split into multiple rows as shown in the second table in the image. Would appreciate any help: Page 2 Attempted ...
0
votes
2answers
64 views

multiple entries from existing excel file

our customer provides us with an excel file listing drivers names and the number of tickets they get for a free drawing, such as "bill smith (next column) 17 tickets is there a way to take that and ...
0
votes
0answers
34 views

Transposing data in Excel from many rows to single column

I have an irregularly formatted workbook, showing hourly averages of utility data. The data is arranged so that every day is its own row and every hour has its own column. How do I best arrange this ...
0
votes
0answers
31 views

Split row into multiple rows if not empty - Excel [closed]

I would like an Excel formula that will help me split entries in a single row into multiple rows as shown in the second table in the image. Would appreciate any help: Click link to view image ...

15 30 50 per page