Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-21-2015, 12:28 AM
randhawa_125 randhawa_125 is offline Export Data on new Sheet with same Id of that column Windows 7 32bit Export Data on new Sheet with same Id of that column Office 2007
Novice
Export Data on new Sheet with same Id of that column
 
Join Date: Feb 2015
Posts: 2
randhawa_125 is on a distinguished road
Default Export Data on new Sheet with same Id of that column


First of all let me tell you all that i am totally new to Excel. I never used it before.. I am in a little trouble, so i need help of your guyz... Hope you guyz will help me.

My Problem is :

I have two columns "Sr.No" and "Previous Posting" as showing in the image 1 (Current Situation). Sr.No columns contains numbers in series and "Previous posting" contains all the posting details in the same column but in different rows..

Now i want to save all these posting details in a new sheet but not in a single column. Every posting detail should be in a new row with same Serial Number which belongs to that column, rather than all the posting record in a single column.

Results should be like as showing in image 2:

I hope you will understand my question and suggest me how to do this as i am totally new.
Attached Files
File Type: xlsx 1234.xlsx (29.2 KB, 9 views)

Last edited by randhawa_125; 02-21-2015 at 01:40 AM.
Reply With Quote
  #2  
Old 02-21-2015, 01:32 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Export Data on new Sheet with same Id of that column Windows 7 64bit Export Data on new Sheet with same Id of that column Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Hi and welcome
could you please post your sheet instead of a picture?
Click on " go advanced" then "manage attachments" button
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 02-21-2015, 01:38 AM
randhawa_125 randhawa_125 is offline Export Data on new Sheet with same Id of that column Windows 7 32bit Export Data on new Sheet with same Id of that column Office 2007
Novice
Export Data on new Sheet with same Id of that column
 
Join Date: Feb 2015
Posts: 2
randhawa_125 is on a distinguished road
Default

Here is my Excel Sheet..
Attached Files
File Type: xlsx 1234.xlsx (29.2 KB, 15 views)
Reply With Quote
  #4  
Old 02-23-2015, 08:15 AM
gebobs gebobs is offline Export Data on new Sheet with same Id of that column Windows 7 64bit Export Data on new Sheet with same Id of that column Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Unmerge the cells in the columns A-K. Simply copy the first row of data for each serial# down until you get to the next serial number. Repeat for each. If this is all the data you need to work with, it's just a matter of some elbow grease.
Reply With Quote
  #5  
Old 02-23-2015, 10:29 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Export Data on new Sheet with same Id of that column Windows 7 64bit Export Data on new Sheet with same Id of that column Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Quote:
Originally Posted by gebobs View Post
If this is all the data you need to work with, it's just a matter of some elbow grease.
Is this supplied by Microsoft?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Tags
excel 2007, sql



Similar Threads
Thread Thread Starter Forum Replies Last Post
Populate sheet 3 with data from sheet 1 and sheet 2 speck Excel Programming 0 01-14-2015 07:54 AM
Export Data on new Sheet with same Id of that column Help Coloring a cell in Sheet one if data is missing from another sheet Aeducan Excel 1 06-22-2014 04:49 PM
Export Data on new Sheet with same Id of that column column of data referenced to multiple grids on another sheet zorniac Excel 1 11-15-2013 10:19 PM
Print margin changes when export excel sheet to PDF officeboy09 Excel 0 11-07-2013 12:25 AM
sheet 2 data highlight in sheet 1 gsrikanth Excel 1 04-21-2012 06:25 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft