Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Exclamation Splitting single table to multiple tables?!

Hey guys I need to submit a report to my boss and I can't seem to find a way to split a single table into multiple tables! So currently its:

Name Age Email
Joanna 31 x
Albert 32 y
Michaela 40 z

How do you split into 4 separate tables (?):
Table 1
Name: Joanna
Age: 31
Email x

Table 2
Name: Albert
Age: 32
Email: y

Table 3
Name: Michaela
Age: 40
Email: z
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Splitting Text from single cell in column across multiple Columns Harold Excel Worksheet Functions 3 March 14th 10 11:06 AM
Reverse Concatenation (Splitting Single Cell Data into Multiple Ce SirEric Excel Discussion (Misc queries) 5 November 14th 08 09:39 AM
Splitting a multi-column table in single columns Tall Bill Excel Discussion (Misc queries) 3 May 30th 08 11:18 PM
Multiple Pivot Tables with single Page Field cscribner Excel Discussion (Misc queries) 1 May 26th 05 12:26 AM
Copying multiple tables to single worksheet Nigel[_5_] Excel Programming 0 November 13th 03 09:32 AM


All times are GMT +1. The time now is 07:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"