I have a sheet that can be varied columns wide. I need to search down and
if the value in Row 2 col A is the same as the Row 1 col A, then take the
data from Row 2 and append it to the end of the data already in Row 1.
Then continue searching down the remainder of the rows for the same and
move as already listed. In most cases there will be only 2 rows that are
the same. The sheet is actually 41 columns wide but I just pased a
sample. I have seen many things on this, but it is usually calculating an
amount when these rows are combined and I don't want this, I just need to
move the data. Thanks for any help you can give..
SSN FileName Name1 Value1 Name2 444112222 w4101-1.13.0
FED.additionalFedWithholding 25 FED.exemptFromFedWithholding 444112222
mo101-1.13.0 MO.filingStatus M MO.spouseWorks 444551111 w4101-1.13.0
FED.additionalFedWithholding 25 FED.exemptFromFedWithholding 444551111
mo101-1.13.0 MO.filingStatus M MO.spouseWorks
Becomes this.... SSN FileName Name1 Value1 Name2 444112222
w4101-1.13.0 FED.additionalFedWithholding 25 FED.exemptFromFedWithholding
444112222 mo101-1.13.0 MO.filingStatus M MO.spouseWorks 444551111
w4101-1.13.0 FED.additionalFedWithholding 25 FED.exemptFromFedWithholding
444551111 mo101-1.13.0 MO.filingStatus M MO.spouseWorks
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.
