|
|
#1
02-07-2018, 05:05 AM
|
|||
|
|||
Split data in cells and duplicate rows
I apologise if this question has been asked before, but I have not been able to find a satisfactory answer. So I thought I'd ask it here.
I have a set of data which is structured this way: Code:
QuoteID | QuoteContent | Document | Cited References Quote1 | lorem ipsum... | Doc1 | Reference1, Reference2, Reference3
In practice, the data should then look like this: Code:
QuoteID | QuoteContent | Document | Cited References Quote1 | lorem ipsum... | Doc1 | Reference1 Quote1 | lorem ipsum... | Doc1 | Reference2 Quote1 | lorem ipsum... | Doc1 | Reference3 Thank you ever so much! 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to find duplicate rows in a huge excel file containing 500000 rows | Stc25234 | Excel Programming | 2 | 06-23-2017 10:51 AM |
| eliminating blan rows between cells in a column cantaining data | FUGMAN | Excel Programming | 6 | 03-01-2017 07:35 AM |
 Merge duplicate rows but retain data from one column
|
Willem113 | Excel | 1 | 09-21-2016 05:42 PM |
| how to split merged data into vertical saperate cells | cheekugreat | Excel | 5 | 10-11-2014 05:53 AM |
| Losing rows when pasting split cells | Gitley | Word Tables | 1 | 01-15-2013 07:49 AM |
Windows 10 
Office 2016
Threaded Mode