Excel formula function or macro? Data Migration for Horizontal Columns to Vertical Columns

%3CLINGO-SUB%20id%3D%22lingo-sub-1954636%22%20slang%3D%22en-US%22%3EExcel%20formula%20function%20or%20macro%3F%20Data%20Migration%20for%20Horizontal%20Columns%20to%20Vertical%20Columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1954636%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EExcel%20formula%20function%20or%20macro%3F%20Data%20Migration%20for%20Horizontal%20Columns%20to%20Vertical%20Columns%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EThis%20must%20be%20a%20common%20problem%3F%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EI%20have%20old%20database%20exported%20to%20csv.%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EThe%20Old%20columns%20are%3B%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20Name%20Surname%20DOB%201%20Address%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EThe%20new%20database%20format%20-%20Columns%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1%20First%20name%201%20Surname%201%20DOB%201%201%20Address%202%20First%20name%202%20Surname%202%20DOB%203%20First%20name%203%20Surname%203%20DOB%204%20First%20name%204%20Surname%204%20DOB%205%20First%20name%205%20Surname%205%20DOB%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EI%20have%20over%206500%20Row%20of%20data%20to%20migration.%3C%2FP%3E%3CDIV%20class%3D%22_2-UiOdhyj4wHBv7Rc2FeDr%20c1cmiB1jfdq4sxidlPDAx%22%3E%3CDIV%20class%3D%22_3Oa0THmZ3f5iZXAQ0hBJ0k%20_2LjgQiHLCZ9LDbCQx5KaOi%22%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CTABLE%20width%3D%221789%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22128%22%3E1%20First%20name%3C%2FTD%3E%3CTD%20width%3D%2292%22%3E1%20Surname%3C%2FTD%3E%3CTD%20width%3D%22116%22%3E1%20DOB%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2299%22%3E1%201%20Adresss%3C%2FTD%3E%3CTD%20width%3D%22111%22%3E2%20First%20name%3C%2FTD%3E%3CTD%20width%3D%2296%22%3E2%20Surname%3C%2FTD%3E%3CTD%20width%3D%22119%22%3E2%20DOB%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E3%20First%20name%3C%2FTD%3E%3CTD%20width%3D%22116%22%3E3%20Surname%3C%2FTD%3E%3CTD%20width%3D%22125%22%3E3%20DOB%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E4%20First%20name%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E4%20Surname%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E4%20DOB%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22119%22%3E5%20First%20name%3C%2FTD%3E%3CTD%20width%3D%22113%22%3E5%20Surname%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E5%20DOB%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%20class%3D%22FJNSiirwoPtG58aeGw2Jx%22%3EColumns%20from%20above%20formatted%20better%3C%2FP%3E%3CP%20class%3D%22FJNSiirwoPtG58aeGw2Jx%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EI%20need%20an%20Automated%20process%20to%20move%20the%20data%3F%20So%20would%20this%20be%20formula%20function%20or%20macro%3F%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EHere%20is%20the%20As%20Is%20format%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22505%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22103%22%3EFirst%20Name%3C%2FTD%3E%3CTD%20width%3D%22108%22%3ESurname%3C%2FTD%3E%3CTD%20width%3D%22133%22%3EDOB%3C%2FTD%3E%3CTD%20width%3D%22161%22%3E1%20address%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EAlan%3C%2FTD%3E%3CTD%3ESmith%3C%2FTD%3E%3CTD%3E01%2F01%2F1959%3C%2FTD%3E%3CTD%3E1%20Murton%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EGavin%26nbsp%3B%3C%2FTD%3E%3CTD%3ESmith%3C%2FTD%3E%3CTD%3E02%2F01%2F1959%3C%2FTD%3E%3CTD%3E1%20Murton%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EJustin%26nbsp%3B%3C%2FTD%3E%3CTD%3ESmith%3C%2FTD%3E%3CTD%3E03%2F01%2F1959%3C%2FTD%3E%3CTD%3E1%20Murton%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EBill%26nbsp%3B%3C%2FTD%3E%3CTD%3ESmith%3C%2FTD%3E%3CTD%3E04%2F01%2F1959%3C%2FTD%3E%3CTD%3E1%20Murton%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EKate%3C%2FTD%3E%3CTD%3ESmith%3C%2FTD%3E%3CTD%3E05%2F01%2F1959%3C%2FTD%3E%3CTD%3E1%20Murton%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETony%3C%2FTD%3E%3CTD%3EJones%3C%2FTD%3E%3CTD%3E06%2F01%2F1959%3C%2FTD%3E%3CTD%3E2%20Murton%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELee%3C%2FTD%3E%3CTD%3EJones%3C%2FTD%3E%3CTD%3E07%2F01%2F1959%3C%2FTD%3E%3CTD%3E2%20Murton%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EOlivia%3C%2FTD%3E%3CTD%3EJones%3C%2FTD%3E%3CTD%3E08%2F01%2F1959%3C%2FTD%3E%3CTD%3E2%20Murton%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENoah%3C%2FTD%3E%3CTD%3EKing%3C%2FTD%3E%3CTD%3E09%2F01%2F1959%3C%2FTD%3E%3CTD%3E3%20Murton%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EOliver%3C%2FTD%3E%3CTD%3ESMITH%3C%2FTD%3E%3CTD%3E10%2F01%2F1959%3C%2FTD%3E%3CTD%3E4%20Murton%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EWilliam%3C%2FTD%3E%3CTD%3EJOHNSON%3C%2FTD%3E%3CTD%3E11%2F01%2F1959%3C%2FTD%3E%3CTD%3E4%20Murton%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EElijah%3C%2FTD%3E%3CTD%3EWILLIAMS%3C%2FTD%3E%3CTD%3E12%2F01%2F1959%3C%2FTD%3E%3CTD%3E4%20Murton%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EJames%3C%2FTD%3E%3CTD%3EJONES%3C%2FTD%3E%3CTD%3E13%2F01%2F1959%3C%2FTD%3E%3CTD%3E4%20Murton%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EBenjamin%3C%2FTD%3E%3CTD%3EBROWN%3C%2FTD%3E%3CTD%3E14%2F01%2F1959%3C%2FTD%3E%3CTD%3E4%20Murton%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELucas%3C%2FTD%3E%3CTD%3EDAVIS%3C%2FTD%3E%3CTD%3E15%2F01%2F1959%3C%2FTD%3E%3CTD%3E7%20Murton%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EMason%3C%2FTD%3E%3CTD%3EMILLER%3C%2FTD%3E%3CTD%3E16%2F01%2F1959%3C%2FTD%3E%3CTD%3E7%20Murton%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EEthan%3C%2FTD%3E%3CTD%3EWILSON%3C%2FTD%3E%3CTD%3E17%2F01%2F1959%3C%2FTD%3E%3CTD%3E7%20Murton%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EEmma%3C%2FTD%3E%3CTD%3EMOORE%3C%2FTD%3E%3CTD%3E18%2F01%2F1959%3C%2FTD%3E%3CTD%3E7%20Murton%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EAva%3C%2FTD%3E%3CTD%3ETAYLOR%3C%2FTD%3E%3CTD%3E19%2F01%2F1959%3C%2FTD%3E%3CTD%3E8%20Murton%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESophia%3C%2FTD%3E%3CTD%3EANDERSON%3C%2FTD%3E%3CTD%3E20%2F01%2F1959%3C%2FTD%3E%3CTD%3E8%20Murton%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EIsabella%3C%2FTD%3E%3CTD%3ETHOMAS%3C%2FTD%3E%3CTD%3E21%2F01%2F1959%3C%2FTD%3E%3CTD%3E8%20Murton%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECharlotte%3C%2FTD%3E%3CTD%3EJACKSON%3C%2FTD%3E%3CTD%3E22%2F01%2F1959%3C%2FTD%3E%3CTD%3E9%20Murton%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EAmelia%3C%2FTD%3E%3CTD%3EWHITE%3C%2FTD%3E%3CTD%3E23%2F01%2F1959%3C%2FTD%3E%3CTD%3E9%20Murton%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EMia%3C%2FTD%3E%3CTD%3EHARRIS%3C%2FTD%3E%3CTD%3E24%2F01%2F1959%3C%2FTD%3E%3CTD%3E10%20Murton%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EHarper%3C%2FTD%3E%3CTD%3EMARTIN%3C%2FTD%3E%3CTD%3E25%2F01%2F1959%3C%2FTD%3E%3CTD%3E10%20Murton%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EEvelyn%3C%2FTD%3E%3CTD%3ETHOMPSON%3C%2FTD%3E%3CTD%3E26%2F01%2F1959%3C%2FTD%3E%3CTD%3E10%20Murton%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CDIV%20class%3D%22_2-UiOdhyj4wHBv7Rc2FeDr%20c1cmiB1jfdq4sxidlPDAx%22%3E%3CDIV%20class%3D%22_3Oa0THmZ3f5iZXAQ0hBJ0k%20_2LjgQiHLCZ9LDbCQx5KaOi%22%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%20class%3D%22FJNSiirwoPtG58aeGw2Jx%22%3EExample%201%3C%2FP%3E%3CP%20class%3D%22FJNSiirwoPtG58aeGw2Jx%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EHere%20is%20the%20TO%20BE%20Format%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22_2-UiOdhyj4wHBv7Rc2FeDr%20c1cmiB1jfdq4sxidlPDAx%22%3E%3CDIV%20class%3D%22_3Oa0THmZ3f5iZXAQ0hBJ0k%20_2LjgQiHLCZ9LDbCQx5KaOi%22%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CTABLE%20width%3D%221789%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22128%22%3E1%20First%20name%3C%2FTD%3E%3CTD%20width%3D%2292%22%3E1%20Surance%3C%2FTD%3E%3CTD%20width%3D%22116%22%3E1%20DOB%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2299%22%3E1%201%20Adresss%3C%2FTD%3E%3CTD%20width%3D%22111%22%3E2%20First%20name%3C%2FTD%3E%3CTD%20width%3D%2296%22%3E2%20Surance%3C%2FTD%3E%3CTD%20width%3D%22119%22%3E2%20DOB%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E3%20First%20name%3C%2FTD%3E%3CTD%20width%3D%22116%22%3E3%20Surance%3C%2FTD%3E%3CTD%20width%3D%22125%22%3E3%20DOB%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E4%20First%20name%3C%2FTD%3E%3CTD%20width%3D%2287%22%3E4%20Surance%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E4%20DOB%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22119%22%3E5%20First%20name%3C%2FTD%3E%3CTD%20width%3D%22113%22%3E5%20Surance%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E5%20DOB%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EAlan%3C%2FTD%3E%3CTD%3ESmith%3C%2FTD%3E%3CTD%3E01%2F01%2F1959%3C%2FTD%3E%3CTD%3E1%20Murton%3C%2FTD%3E%3CTD%3EGavin%26nbsp%3B%3C%2FTD%3E%3CTD%3ESmith%3C%2FTD%3E%3CTD%3E02%2F01%2F1959%3C%2FTD%3E%3CTD%3EJustin%26nbsp%3B%3C%2FTD%3E%3CTD%3ESmith%3C%2FTD%3E%3CTD%3E03%2F01%2F1959%3C%2FTD%3E%3CTD%3EBill%26nbsp%3B%3C%2FTD%3E%3CTD%3ESmith%3C%2FTD%3E%3CTD%3E04%2F01%2F1959%3C%2FTD%3E%3CTD%3EKate%3C%2FTD%3E%3CTD%3ESmith%3C%2FTD%3E%3CTD%3E05%2F01%2F1959%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EMia%3C%2FTD%3E%3CTD%3EHARRIS%3C%2FTD%3E%3CTD%3E24%2F01%2F1959%3C%2FTD%3E%3CTD%3E10%20Murton%3C%2FTD%3E%3CTD%3EHarper%3C%2FTD%3E%3CTD%3EMARTIN%3C%2FTD%3E%3CTD%3E25%2F01%2F1959%3C%2FTD%3E%3CTD%3EEvelyn%3C%2FTD%3E%3CTD%3ETHOMPSON%3C%2FTD%3E%3CTD%3E26%2F01%2F1959%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETony%3C%2FTD%3E%3CTD%3EJones%3C%2FTD%3E%3CTD%3E06%2F01%2F1959%3C%2FTD%3E%3CTD%3E2%20Murton%3C%2FTD%3E%3CTD%3ELee%3C%2FTD%3E%3CTD%3EJones%3C%2FTD%3E%3CTD%3E07%2F01%2F1959%3C%2FTD%3E%3CTD%3EOlivia%3C%2FTD%3E%3CTD%3EJones%3C%2FTD%3E%3CTD%3E08%2F01%2F1959%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENoah%3C%2FTD%3E%3CTD%3EKing%3C%2FTD%3E%3CTD%3E09%2F01%2F1959%3C%2FTD%3E%3CTD%3E3%20Murton%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EOliver%3C%2FTD%3E%3CTD%3ESMITH%3C%2FTD%3E%3CTD%3E10%2F01%2F1959%3C%2FTD%3E%3CTD%3E4%20Murton%3C%2FTD%3E%3CTD%3EWilliam%3C%2FTD%3E%3CTD%3EJOHNSON%3C%2FTD%3E%3CTD%3E11%2F01%2F1959%3C%2FTD%3E%3CTD%3EElijah%3C%2FTD%3E%3CTD%3EWILLIAMS%3C%2FTD%3E%3CTD%3E12%2F01%2F1959%3C%2FTD%3E%3CTD%3EJames%3C%2FTD%3E%3CTD%3EJONES%3C%2FTD%3E%3CTD%3E13%2F01%2F1959%3C%2FTD%3E%3CTD%3EBenjamin%3C%2FTD%3E%3CTD%3EBROWN%3C%2FTD%3E%3CTD%3E14%2F01%2F1959%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELucas%3C%2FTD%3E%3CTD%3EDAVIS%3C%2FTD%3E%3CTD%3E15%2F01%2F1959%3C%2FTD%3E%3CTD%3E7%20Murton%3C%2FTD%3E%3CTD%3EMason%3C%2FTD%3E%3CTD%3EMILLER%3C%2FTD%3E%3CTD%3E16%2F01%2F1959%3C%2FTD%3E%3CTD%3EEthan%3C%2FTD%3E%3CTD%3EWILSON%3C%2FTD%3E%3CTD%3E17%2F01%2F1959%3C%2FTD%3E%3CTD%3EEmma%3C%2FTD%3E%3CTD%3EMOORE%3C%2FTD%3E%3CTD%3E18%2F01%2F1959%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EAva%3C%2FTD%3E%3CTD%3ETAYLOR%3C%2FTD%3E%3CTD%3E19%2F01%2F1959%3C%2FTD%3E%3CTD%3E8%20Murton%3C%2FTD%3E%3CTD%3ESophia%3C%2FTD%3E%3CTD%3EANDERSON%3C%2FTD%3E%3CTD%3E20%2F01%2F1959%3C%2FTD%3E%3CTD%3EIsabella%3C%2FTD%3E%3CTD%3ETHOMAS%3C%2FTD%3E%3CTD%3E21%2F01%2F1959%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECharlotte%3C%2FTD%3E%3CTD%3EJACKSON%3C%2FTD%3E%3CTD%3E22%2F01%2F1959%3C%2FTD%3E%3CTD%3E9%20Murton%3C%2FTD%3E%3CTD%3EAmelia%3C%2FTD%3E%3CTD%3EWHITE%3C%2FTD%3E%3CTD%3E23%2F01%2F1959%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%20class%3D%22FJNSiirwoPtG58aeGw2Jx%22%3EExample%202%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EI%20am%20currently%20just%20using%20the%20filter%20by%201%20address%20to%20copy%20and%20paste%20the%20data.%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EAny%20thoughts%20or%20feedback%20would%20be%20greatly%20appreciated!%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EI%20have%20a%20sample%20excel%20file%20if%20needed.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1954636%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1954990%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20function%20or%20macro%3F%20Data%20Migration%20for%20Horizontal%20Columns%20to%20Vertical%20Columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1954990%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F890485%22%20target%3D%22_blank%22%3E%40sashakorniakUK%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EVBA%20or%20Power%20Query%20would%20probably%20be%20the%20best%20approach.%20Can%20you%20share%20your%20workbook%20to%20further%20test%20the%20dataset%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1955361%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20function%20or%20macro%3F%20Data%20Migration%20for%20Horizontal%20Columns%20to%20Vertical%20Columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1955361%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F867265%22%20target%3D%22_blank%22%3E%40adversi%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%60Hey%20there%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETrust%20you%20are%20well%20and%20happy%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20helping%20with%20this.%20I%20have%20attached%20the%20example%20workbook.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1955662%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20function%20or%20macro%3F%20Data%20Migration%20for%20Horizontal%20Columns%20to%20Vertical%20Columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1955662%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F890485%22%20target%3D%22_blank%22%3E%40sashakorniakUK%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F867265%22%20target%3D%22_blank%22%3E%40adversi%3C%2FA%3E%26nbsp%3B%20Here%20a%20Gif%20video%20to%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1956325%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20function%20or%20macro%3F%20Data%20Migration%20for%20Horizontal%20Columns%20to%20Vertical%20Columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1956325%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F890485%22%20target%3D%22_blank%22%3E%40sashakorniakUK%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F867265%22%20target%3D%22_blank%22%3E%40adversi%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EI%20have%20been%20using%20power%20query%20to%20find%20a%20solution%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3ESo%20far%20I%20found%20this%20works%2C%20however%20I%20not%20find%20my%2065000%20rows%20of%20data%20has%20more%20than%205%20names%20per%20address.%20However%20I%20need%20to%20either%20add%20names%206%2B%20to%20a%20new%20row%20or%20stop%20that%20a%20source%20etc.%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3Ehere%20the%20code%20so%20far%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3Elet%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Source%20%3D%20Excel.CurrentWorkbook()%7B%5BName%3D%22Table1%22%5D%7D%5BContent%5D%2C%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%23%22Changed%20Type%22%20%3D%20Table.TransformColumnTypes(Source%2C%7B%7B%22First%20Name%22%2C%20type%20text%7D%2C%20%7B%22Surance%22%2C%20type%20text%7D%2C%20%7B%22DOB%22%2C%20type%20text%7D%2C%20%7B%221%20address%22%2C%20type%20text%7D%7D)%2C%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%23%22Unpivoted%20Columns%22%20%3D%20Table.UnpivotOtherColumns(%23%22Changed%20Type%22%2C%20%7B%221%20address%22%7D%2C%20%22Attribute%22%2C%20%22Value%22)%2C%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%23%22Grouped%20Rows%22%20%3D%20Table.Group(%23%22Unpivoted%20Columns%22%2C%20%7B%221%20address%22%7D%2C%20%7B%7B%22Count%22%2C%20each%20_%2C%20type%20table%7D%7D)%2C%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%23%22Added%20Custom%22%20%3D%20Table.AddColumn(%23%22Grouped%20Rows%22%2C%20%22Custom%22%2C%20each%20Text.Combine(%5BCount%5D%5BValue%5D%2C%22%2C%23%23%2C%22))%2C%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%23%22Split%20Column%20by%20Delimiter%22%20%3D%20Table.SplitColumn(%23%22Added%20Custom%22%2C%20%22Custom%22%2C%20Splitter.SplitTextByDelimiter(%22%2C%23%23%2C%22%2C%20QuoteStyle.Csv)%2C%20%7B%22Custom.1%22%2C%20%22Custom.2%22%2C%20%22Custom.3%22%2C%20%22Custom.4%22%2C%20%22Custom.5%22%2C%20%22Custom.6%22%2C%20%22Custom.7%22%2C%20%22Custom.8%22%2C%20%22Custom.9%22%2C%20%22Custom.10%22%2C%20%22Custom.11%22%2C%20%22Custom.12%22%2C%20%22Custom.13%22%2C%20%22Custom.14%22%2C%20%22Custom.15%22%7D)%2C%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%23%22Changed%20Type1%22%20%3D%20Table.TransformColumnTypes(%23%22Split%20Column%20by%20Delimiter%22%2C%7B%7B%22Custom.1%22%2C%20type%20text%7D%2C%20%7B%22Custom.2%22%2C%20type%20text%7D%2C%20%7B%22Custom.3%22%2C%20type%20datetime%7D%2C%20%7B%22Custom.4%22%2C%20type%20text%7D%2C%20%7B%22Custom.5%22%2C%20type%20text%7D%2C%20%7B%22Custom.6%22%2C%20type%20datetime%7D%2C%20%7B%22Custom.7%22%2C%20type%20text%7D%2C%20%7B%22Custom.8%22%2C%20type%20text%7D%2C%20%7B%22Custom.9%22%2C%20type%20datetime%7D%2C%20%7B%22Custom.10%22%2C%20type%20text%7D%2C%20%7B%22Custom.11%22%2C%20type%20text%7D%2C%20%7B%22Custom.12%22%2C%20type%20datetime%7D%2C%20%7B%22Custom.13%22%2C%20type%20text%7D%2C%20%7B%22Custom.14%22%2C%20type%20text%7D%2C%20%7B%22Custom.15%22%2C%20type%20datetime%7D%7D)%2C%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%23%22Removed%20Columns1%22%20%3D%20Table.RemoveColumns(%23%22Changed%20Type1%22%2C%7B%22Count%22%7D)%2C%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%23%22Changed%20Type2%22%20%3D%20Table.TransformColumnTypes(%23%22Removed%20Columns1%22%2C%7B%7B%22Custom.3%22%2C%20type%20date%7D%2C%20%7B%22Custom.6%22%2C%20type%20date%7D%2C%20%7B%22Custom.9%22%2C%20type%20date%7D%2C%20%7B%22Custom.12%22%2C%20type%20date%7D%2C%20%7B%22Custom.15%22%2C%20type%20date%7D%7D)%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3Ein%3C%2FP%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%23%22Changed%20Type2%22%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Excel formula function or macro? Data Migration for Horizontal Columns to Vertical Columns

 

This must be a common problem? 

 

I have old database exported to csv.

The Old columns are;

 

First Name Surname DOB 1 Address

 

The new database format - Columns

 

 

1 First name 1 Surname 1 DOB 1 1 Address 2 First name 2 Surname 2 DOB 3 First name 3 Surname 3 DOB 4 First name 4 Surname 4 DOB 5 First name 5 Surname 5 DOB

 

                

 

I have over 6500 Row of data to migration.

 
1 First name1 Surname1 DOB 1 1 Adresss2 First name2 Surname2 DOB 3 First name3 Surname3 DOB 4 First name4 Surname4 DOB 5 First name5 Surname5 DOB 

Columns from above formatted better

 

I need an Automated process to move the data? So would this be formula function or macro?

 

Here is the As Is format

 

First NameSurnameDOB1 address
AlanSmith01/01/19591 Murton
Gavin Smith02/01/19591 Murton
Justin Smith03/01/19591 Murton
Bill Smith04/01/19591 Murton
KateSmith05/01/19591 Murton
TonyJones06/01/19592 Murton
LeeJones07/01/19592 Murton
OliviaJones08/01/19592 Murton
NoahKing09/01/19593 Murton 
OliverSMITH10/01/19594 Murton
WilliamJOHNSON11/01/19594 Murton
ElijahWILLIAMS12/01/19594 Murton
JamesJONES13/01/19594 Murton
BenjaminBROWN14/01/19594 Murton
LucasDAVIS15/01/19597 Murton
MasonMILLER16/01/19597 Murton
EthanWILSON17/01/19597 Murton
EmmaMOORE18/01/19597 Murton
AvaTAYLOR19/01/19598 Murton
SophiaANDERSON20/01/19598 Murton
IsabellaTHOMAS21/01/19598 Murton
CharlotteJACKSON22/01/19599 Murton
AmeliaWHITE23/01/19599 Murton
MiaHARRIS24/01/195910 Murton
HarperMARTIN25/01/195910 Murton
EvelynTHOMPSON26/01/195910 Murton
 

 

Example 1

 

Here is the TO BE Format

 

 
1 First name1 Surance1 DOB 1 1 Adresss2 First name2 Surance2 DOB 3 First name3 Surance3 DOB 4 First name4 Surance4 DOB 5 First name5 Surance5 DOB 
AlanSmith01/01/19591 MurtonGavin Smith02/01/1959Justin Smith03/01/1959Bill Smith04/01/1959KateSmith05/01/1959
MiaHARRIS24/01/195910 MurtonHarperMARTIN25/01/1959EvelynTHOMPSON26/01/1959      
TonyJones06/01/19592 MurtonLeeJones07/01/1959OliviaJones08/01/1959      
NoahKing09/01/19593 Murton             
OliverSMITH10/01/19594 MurtonWilliamJOHNSON11/01/1959ElijahWILLIAMS12/01/1959JamesJONES13/01/1959BenjaminBROWN14/01/1959
LucasDAVIS15/01/19597 MurtonMasonMILLER16/01/1959EthanWILSON17/01/1959EmmaMOORE18/01/1959   
AvaTAYLOR19/01/19598 MurtonSophiaANDERSON20/01/1959IsabellaTHOMAS21/01/1959      
CharlotteJACKSON22/01/19599 MurtonAmeliaWHITE23/01/1959         

 

Example 2

I am currently just using the filter by 1 address to copy and paste the data.

Any thoughts or feedback would be greatly appreciated!

I have a sample excel file if needed.

10 Replies

@sashakorniakUK 

VBA or Power Query would probably be the best approach. Can you share your workbook to further test the dataset? 

@adversi 

 

`Hey there, 

 

Trust you are well and happy?

 

Thank you for helping with this. I have attached the example workbook. 

 

@sashakorniakUK @adversi 

 

I have been using power query to find a solution

So far I found this works, however I not find my 65000 rows of data has more than 5 names per address. However I need to either add names 6+ to a new row or stop that a source etc.

 

here the code so far

 

let

    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],

    #"Changed Type" = Table.TransformColumnTypes(Source,{{"First Name", type text}, {"Surance", type text}, {"DOB", type text}, {"1 address", type text}}),

    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"1 address"}, "Attribute", "Value"),

    #"Grouped Rows" = Table.Group(#"Unpivoted Columns", {"1 address"}, {{"Count", each _, type table}}),

    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Text.Combine([Count][Value],",##,")),

    #"Split Column by Delimiter" = Table.SplitColumn(#"Added Custom", "Custom", Splitter.SplitTextByDelimiter(",##,", QuoteStyle.Csv), {"Custom.1", "Custom.2", "Custom.3", "Custom.4", "Custom.5", "Custom.6", "Custom.7", "Custom.8", "Custom.9", "Custom.10", "Custom.11", "Custom.12", "Custom.13", "Custom.14", "Custom.15"}),

    #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Custom.1", type text}, {"Custom.2", type text}, {"Custom.3", type datetime}, {"Custom.4", type text}, {"Custom.5", type text}, {"Custom.6", type datetime}, {"Custom.7", type text}, {"Custom.8", type text}, {"Custom.9", type datetime}, {"Custom.10", type text}, {"Custom.11", type text}, {"Custom.12", type datetime}, {"Custom.13", type text}, {"Custom.14", type text}, {"Custom.15", type datetime}}),

    #"Removed Columns1" = Table.RemoveColumns(#"Changed Type1",{"Count"}),

    #"Changed Type2" = Table.TransformColumnTypes(#"Removed Columns1",{{"Custom.3", type date}, {"Custom.6", type date}, {"Custom.9", type date}, {"Custom.12", type date}, {"Custom.15", type date}})

in

    #"Changed Type2"

@sashakorniakUK 

Same idea, but without hardcoding column names

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Grouped Rows" = Table.Group(
        Source,
        {"address"},
        {
            {"Tables",
             each
[   #"Removed Columns" = Table.RemoveColumns(_,{"address"}),
    #"Added Index" = Table.AddIndexColumn(
        #"Removed Columns",
        "Index", 1, 1, Int64.Type
    ),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(
        #"Added Index",
        {"Index"}, "Attribute", "Value"
    ),
    #"Merged Columns" = Table.CombineColumns(
        Table.TransformColumnTypes(
            #"Unpivoted Other Columns",
                {{"Index", type text}}, "en-GB"
            ),
            {"Attribute", "Index"},
            Combiner.CombineTextByDelimiter(" ", QuoteStyle.None),"Merged"
    ),
    #"Transposed Table1" = Table.Transpose(#"Merged Columns"),
    #"Promoted Headers" = Table.PromoteHeaders(
        #"Transposed Table1",
        [PromoteAllScalars=true]
    )
][#"Promoted Headers"]
            },
            {"Count", each Table.RowCount(_), Int64.Type}
        }
    ),
    // Generate Column Names
    MaxRows = List.Max(#"Grouped Rows"[Count]),
 
    RemoveAddress = Table.RemoveColumns(Source,{"address"}),
    #"Kept First Rows" = Table.FirstN(RemoveAddress,1),
    #"Added Custom" = Table.AddColumn(#"Kept First Rows", "Index", each {1..MaxRows}),
    #"Expanded Index" = Table.ExpandListColumn(#"Added Custom", "Index"),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Expanded Index", {"Index"}, "Attribute", "Value"),
    GetTogether = Table.CombineColumns(
        Table.TransformColumnTypes(
            #"Unpivoted Other Columns",
            {{"Index", type text}}, "en-GB"),{"Attribute", "Index"},
            Combiner.CombineTextByDelimiter(" ", QuoteStyle.None),"ColumnNames"
    ),
    ColumnNames = GetTogether[ColumnNames],
 
 
    #"Expanded Tables" = Table.ExpandTableColumn(#"Grouped Rows", "Tables", ColumnNames)
in
    #"Expanded Tables"

image.png

 

@Sergei Baklan  - I cannot download the file?

 

testing the code shortly.

 

Any thoughts on the issue with if an address has more than 5 names?

@sashakorniakUK 

1) I repeated the file

2) Nope, no problem if less than 5. They are if you add one more

@sashakorniakUK 
Sorry for that, I was not able to download it back as well. One in previous post works with me.