Hi all,
I need some help here to extract some data which I need to convert into another format.
Table in Row 2 and Row 3 is original data.
Table Row 5 to Row 34 is output data.
\1
Anyone here knows the formula to convert the original data (Column C & E) to another format like output data (Row 5 to Row 34)
1. Original data which is calling for ABCDE (Column C) and U2 U3 U4 U5 U6 U7 U8 U9 (Column E) convert into
ABCDE U2
ABCDE U3
ABCDE U4
ABCDE U5
ABCDE U6
ABCDE U7
ABCDE U8
ABCDE U9
2. The next data 12345 (column C) and C7-C20 C28 C30 C32 C37-C40 (Column E).
For C7-C20
12345 C7
12345 C8
12345 C9
12345 C10
12345 C11
12345 C12
12345 C13
12345 C14
12345 C15
12345 C16
12345 C17
12345 C18
12345 C19
12345 C20
Bookmarks