ExcelNewbie2020
Active Member
- Joined
- Dec 3, 2020
- Messages
- 293
- Office Version
- 365
- Platform
- Windows
Sirs, using excel formula how to replicate data based on the result of of textsplit values.
based on my table below, columns A to E got replicated because of textsplit from column F. thank you
based on my table below, columns A to E got replicated because of textsplit from column F. thank you
Sample_practice.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | No | make | Date | code | loc | place | ||
2 | 1 | A | 2023-03-05 | ABC123 | india | uk,us,india | ||
3 | 2 | b | 2022-12-25 | DEF245 | uk | malta,us,uk | ||
4 | 3 | c | 2022-12-12 | HIJ256 | us | rus,us | ||
5 | ||||||||
6 | ||||||||
7 | ||||||||
8 | ||||||||
9 | ||||||||
10 | ||||||||
11 | ||||||||
12 | ||||||||
13 | expected result | |||||||
14 | No | make | Date | code | loc | place | ||
15 | 1 | A | 2023-03-05 | ABC123 | india | uk | ||
16 | 1 | A | 2023-03-05 | ABC123 | india | us | ||
17 | 1 | A | 2023-03-05 | ABC123 | india | india | ||
18 | 2 | b | 2022-12-25 | DEF245 | uk | malta | ||
19 | 2 | b | 2022-12-25 | DEF245 | uk | us | ||
20 | 2 | b | 2022-12-25 | DEF245 | uk | uk | ||
21 | 3 | c | 2022-12-12 | HIJ256 | us | rus | ||
22 | 3 | c | 2022-12-12 | HIJ256 | us | us | ||
Sheet2 |