MrRajKumar
Active Member
- Joined
- Jan 29, 2008
- Messages
- 280
- Office Version
- 365
- Platform
- Windows
Hello,
I am using M365.
Below is my data setup.
A2:A10 - Item names, say A-I
B2:B10 - Its values, say 1-9
So in C2, I would like to get values joined as follows (A2 value space B2 value comma A3 space B3, A4 space B4 etc...)
A 1, B 2, C 3, D 4, E 5...I 9
Both this range has its own spill.
I am using M365.
Below is my data setup.
A2:A10 - Item names, say A-I
B2:B10 - Its values, say 1-9
So in C2, I would like to get values joined as follows (A2 value space B2 value comma A3 space B3, A4 space B4 etc...)
A 1, B 2, C 3, D 4, E 5...I 9
Both this range has its own spill.