Hi there,
I have an Excel sheet with one column and (for now) 70 rows.
I would like to split that one column into two columns.
I cannot use transpose because there is an image in the cell.
Does anybody has a solution for me ?
I have an Excel sheet with one column and (for now) 70 rows.
I would like to split that one column into two columns.
I cannot use transpose because there is an image in the cell.
Does anybody has a solution for me ?
one_to_many_column.xlsx | |||
---|---|---|---|
A | |||
1 | RED-Can-BG-A.0001 Fictieve ruimte Helpdesk Automatisering | ||
2 | RED-Can-BG-B.0001 Fictieve ruimte Helpdesk Automatisering | ||
3 | RED-Can-BG-BG-E Centrale hal Helpdesk Automatisering | ||
4 | RED-Can-BG-BG-R1 Kamer, gezamenlijk Helpdesk Automatisering | ||
5 | RED-Can-BG-BG-R2 Kamer, gezamenlijk Helpdesk Automatisering | ||
6 | RED-Can-BG-BG-TP Centrale hal Helpdesk Automatisering | ||
7 | RED-Can-BG-TR-M Technisch of tbv onderhoud Helpdesk Automatisering | ||
8 | RED-Can-BG-TR-P Technisch of tbv onderhoud Helpdesk Automatisering | ||
9 | RED-Can-BG-TR-V Technisch of tbv onderhoud Helpdesk Automatisering | ||
10 | RED-MOL-0-007 Clientenkamer Helpdesk Automatisering | ||
11 | RED-MOL-0-008 Clientenkamer Helpdesk Automatisering | ||
12 | RED-MOL-0-009 Clientenkamer Helpdesk Automatisering | ||
13 | RED-MOL-0-010 Clientenkamer Helpdesk Automatisering | ||
14 | RED-MOL-0-011 Clientenkamer Helpdesk Automatisering | ||
15 | RED-MOL-0-012 Clientenkamer Helpdesk Automatisering | ||
16 | RED-MOL-0-013 Clientenkamer Helpdesk Automatisering | ||
17 | RED-MOL-0-014 Clientenkamer Helpdesk Automatisering | ||
18 | RED-MOL-0-BERG Berging Helpdesk Automatisering | ||
19 | RED-MOL-0-ENTREE Gang(deel) Helpdesk Automatisering | ||
20 | RED-MOL-0-GANG Gang(deel) Helpdesk Automatisering | ||
21 | RED-MOL-0-HK Kamer, gezamenlijk Helpdesk Automatisering | ||
22 | RED-MOL-0-WR Sanitair Helpdesk Automatisering | ||
23 | RED-PAS-2-201 Clientenkamer Helpdesk Automatisering | ||
24 | RED-PAS-2-202 Clientenkamer Helpdesk Automatisering | ||
25 | RED-PAS-2-203 Clientenkamer Helpdesk Automatisering | ||
26 | RED-PAS-2-204 Clientenkamer Helpdesk Automatisering | ||
27 | RED-PAS-2-205 Clientenkamer Helpdesk Automatisering | ||
28 | RED-PAS-2-206 Clientenkamer Helpdesk Automatisering | ||
29 | RED-PAS-2-207 Clientenkamer Helpdesk Automatisering | ||
30 | RED-PAS-2-ENTREE Gang(deel) Helpdesk Automatisering | ||
31 | RED-PAS-2-GANG Gang(deel) Helpdesk Automatisering | ||
32 | RED-PAS-2-HK Kamer, gezamenlijk Helpdesk Automatisering | ||
33 | RED-PAS-2-SP Berging Helpdesk Automatisering | ||
34 | RED-PAS-2-WR Sanitair Helpdesk Automatisering | ||
35 | RED-SAS-1-108 Clientenkamer Helpdesk Automatisering | ||
36 | RED-SAS-1-109 Clientenkamer Helpdesk Automatisering | ||
37 | RED-SAS-1-110 Clientenkamer Helpdesk Automatisering | ||
38 | RED-SAS-1-111 Clientenkamer Helpdesk Automatisering | ||
39 | RED-SAS-1-112 Clientenkamer Helpdesk Automatisering | ||
40 | RED-SAS-1-113 Clientenkamer Helpdesk Automatisering | ||
41 | RED-SAS-1-114 Clientenkamer Helpdesk Automatisering | ||
42 | RED-SAS-1-ENTREE Gang(deel) Helpdesk Automatisering | ||
43 | RED-SAS-1-GANG Gang(deel) Helpdesk Automatisering | ||
44 | RED-SAS-1-HK Kamer, gezamenlijk Helpdesk Automatisering | ||
45 | RED-SAS-1-SP Berging Helpdesk Automatisering | ||
46 | RED-SAS-1-WR Sanitair Helpdesk Automatisering | ||
47 | RED-STU-1-101 Clientenkamer Helpdesk Automatisering | ||
48 | RED-STU-1-102 Clientenkamer Helpdesk Automatisering | ||
49 | RED-STU-1-103 Clientenkamer Helpdesk Automatisering | ||
50 | RED-STU-1-104 Clientenkamer Helpdesk Automatisering | ||
51 | RED-STU-1-105 Clientenkamer Helpdesk Automatisering | ||
52 | RED-STU-1-106 Clientenkamer Helpdesk Automatisering | ||
53 | RED-STU-1-107 Clientenkamer Helpdesk Automatisering | ||
54 | RED-STU-1-ENTREE Gang(deel) Helpdesk Automatisering | ||
55 | RED-STU-1-GANG Gang(deel) Helpdesk Automatisering | ||
56 | RED-STU-1-HK Kamer, gezamenlijk Helpdesk Automatisering | ||
57 | RED-STU-1-SP Berging Helpdesk Automatisering | ||
58 | RED-STU-1-WR Sanitair Helpdesk Automatisering | ||
59 | RED-Sta-0-001 Clientenkamer Helpdesk Automatisering | ||
60 | RED-Sta-0-002 Clientenkamer Helpdesk Automatisering | ||
61 | RED-Sta-0-003 Clientenkamer Helpdesk Automatisering | ||
62 | RED-Sta-0-004 Clientenkamer Helpdesk Automatisering | ||
63 | RED-Sta-0-005 Clientenkamer Helpdesk Automatisering | ||
64 | RED-Sta-0-006 Clientenkamer Helpdesk Automatisering | ||
65 | RED-Sta-0-007 Clientenkamer Helpdesk Automatisering | ||
66 | RED-Sta-0-BERG Berging Helpdesk Automatisering | ||
67 | RED-Sta-0-ENTREE Gang(deel) Helpdesk Automatisering | ||
68 | RED-Sta-0-GANG Gang(deel) Helpdesk Automatisering | ||
69 | RED-Sta-0-HK Kamer, gezamenlijk Helpdesk Automatisering | ||
70 | RED-Sta-0-WR Sanitair Helpdesk Automatisering | ||
Blad1 |