Question description:
This user has given permission to use the problem statement for this
blog.
if there are two columns containing name email Telefon n time information. How can we put this info in 4 different columns respectively
Solved by C. F. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
09/12/2017 - 08:39
Welcome, Thanks for choosing Got It Pro-Excel
How may I help you today?
Excelchat Expert
09/12/2017 - 08:39
Will you mind sharing a sample sheet with me that contains the two columns with name email phone number n time
User
09/12/2017 - 08:40
Hi
User
09/12/2017 - 08:40
sheet has been uploaded
User
09/12/2017 - 08:40
can u plz have a look
Excelchat Expert
09/12/2017 - 08:41
I will need to take that file offline to work on it
Excelchat Expert
09/12/2017 - 08:41
Please bear with me
User
09/12/2017 - 08:41
okie
User
09/12/2017 - 08:41
have u understood what i meant
Excelchat Expert
09/12/2017 - 08:41
Please elaborate
Excelchat Expert
09/12/2017 - 08:41
With reference to cell in the sheet
User
09/12/2017 - 08:42
ok
User
09/12/2017 - 08:42
A1 shows time
User
09/12/2017 - 08:42
n its value is in B1
Excelchat Expert
09/12/2017 - 08:42
Yup
Excelchat Expert
09/12/2017 - 08:42
Got it
User
09/12/2017 - 08:42
from A1 to A6
User
09/12/2017 - 08:42
is the info of one customer
Excelchat Expert
09/12/2017 - 08:42
Alright
User
09/12/2017 - 08:43
n similarly from A7 to A12 is the info of other
Excelchat Expert
09/12/2017 - 08:43
Yes
Excelchat Expert
09/12/2017 - 08:43
I got that
User
09/12/2017 - 08:43
i just want all the customer names to fall under the cell name Name
User
09/12/2017 - 08:44
all the telefonnummer, email and time of the customer under the same name respectively
Excelchat Expert
09/12/2017 - 08:44
I got it
User
09/12/2017 - 08:44
i hope m able to express it
Excelchat Expert
09/12/2017 - 08:44
Please review the file I will be sharing with you in a minute
User
09/12/2017 - 08:45
thanks
User
09/12/2017 - 08:49
i hope u ll abe able to do it
Excelchat Expert
09/12/2017 - 08:49
Yes Obviously
Excelchat Expert
09/12/2017 - 08:49
I am on it
User
09/12/2017 - 08:49
oki
User
09/12/2017 - 08:53
?
Excelchat Expert
09/12/2017 - 08:54
PFA
[Uploaded an Excel file]
Excelchat Expert
09/12/2017 - 08:54
Please find the data in sheet 2
User
09/12/2017 - 08:55
well thanks but seems like it is not sorted properly
Excelchat Expert
09/12/2017 - 08:56
Yes
Excelchat Expert
09/12/2017 - 08:56
It has been done using Paste Special and Transpose
Excelchat Expert
09/12/2017 - 08:56
The initial data you provided me was not properly sorted
Excelchat Expert
09/12/2017 - 08:57
I ran a Macro that copied Cell 1-6 and paste special - Transpose
Excelchat Expert
09/12/2017 - 08:57
And then copied Cell 7-12
Excelchat Expert
09/12/2017 - 08:57
And so on
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
