I have a bunch of store numbers in column A and numbers in Column B. I need a formula that will format the sheet so that each item will have their own row for each individual store. So each store should merge 10 rows (one for each item) Does this make sense? Does anyone know how I can do this?
Your example file does not explain very much - please re-submit, showing a BEFORE sheet (i.e. what you have now) and an AFTER sheet (what you would like to achieve).
Hope this helps.
Pete
The above sheet is the before sheet. Attached here is an after sheet that only uses 2 codes out of the 10 I need. I want each store to have a spot for all 10 codes. Thanks
1st, your 2 "sheets" do not have the same data at all, so it is hard to see what you are trying to do.
2nd, there is no formula that will merge cells like you have in your 2nd file. I have a feeling though that you need to look at using a Pivot Table?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I'm sorry, that doesn't make any sense to me. You seem to have the numbers 9840 and 24129 against every store - how do these relate to your BEFORE sheet?
Pete
Im sorry guys, I want to do the same thing that was done with the after "sheet" (which is only 2 codes) to the 10 new codes (doesn't matter that the values are different from the after sheet, only the formatting matters) on the first "sheet." I tried using a pivot table but I cant find a way to set it up to show the way I want it no matter where I put the ID filter. Thats why I was hoping there was a formula that could help.
Forget the value of the numbers on the after sheet. It is only meant to display the formatting I need to achieve on the original 10 codes
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks