Align duplicates from two columns to same rows in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2298105%22%20slang%3D%22en-US%22%3EAlign%20duplicates%20from%20two%20columns%20to%20same%20rows%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2298105%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20following%20situation%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20data%20(Full%20Name%2C%20Column%20A)%20that%20needs%20to%20be%20aligned%20with%20other%20Data%20from%20Column%20C%20on%20(Full%20Name%20and%20beyond).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20a%20very%20similar%20post%20recently.%20But%20the%20formula%20doesn't%20work%20in%20this%20case.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Falign-duplicates-from-two-columns-to-same-rows-in-excel%2Fm-p%2F2273761%23M96440%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Falign-duplicates-from-two-columns-to-same-rows-in-excel%2Fm-p%2F2273761%23M96440%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%223234%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22107.333px%22%3E%3CSTRONG%3EColumn%20A%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2299.3333px%22%3E%3CSTRONG%3EColumn%20B%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2294.6667px%22%3E%3CSTRONG%3EColumn%20C%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%22248px%22%3E%3CSTRONG%3EColumn%20D%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%22145.333px%22%3E%3CSTRONG%3EColumn%20E%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2295.3333px%22%3E%3CSTRONG%3EColumn%20F%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22353.333px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2298.6667px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22116.667px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22109.333px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22147.333px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22283.333px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22355.333px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2278px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2275.3333px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22116.667px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295.3333px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2282px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22118px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268.6667px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268.6667px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268.6667px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22107.333px%22%3EFull%20Name%3C%2FTD%3E%3CTD%20width%3D%2299.3333px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2294.6667px%22%3EFull%20Name%3C%2FTD%3E%3CTD%20width%3D%22248px%22%3EEmail%3C%2FTD%3E%3CTD%20width%3D%22145.333px%22%3EVerify%20Status%3C%2FTD%3E%3CTD%20width%3D%2295.3333px%22%3EFirst%20Name%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3ELast%20Name%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3EFull%20Name%3C%2FTD%3E%3CTD%20width%3D%22353.333px%22%3EUser%20Social%3C%2FTD%3E%3CTD%20width%3D%2298.6667px%22%3EJob%20Position%3C%2FTD%3E%3CTD%20width%3D%22116.667px%22%3EProspect%20Location%3C%2FTD%3E%3CTD%20width%3D%22109.333px%22%3EAdd%20Date%3C%2FTD%3E%3CTD%20width%3D%22147.333px%22%3ECompany%20Name%3C%2FTD%3E%3CTD%20width%3D%22283.333px%22%3ECompany%20Url%3C%2FTD%3E%3CTD%20width%3D%22355.333px%22%3ECompany%20Social%3C%2FTD%3E%3CTD%20width%3D%2278px%22%3ECompany%20Size%3C%2FTD%3E%3CTD%20width%3D%2275.3333px%22%3ECountry%3C%2FTD%3E%3CTD%20width%3D%22116.667px%22%3ELocation%3C%2FTD%3E%3CTD%20width%3D%2295.3333px%22%3EState%3C%2FTD%3E%3CTD%20width%3D%2282px%22%3ECity%3C%2FTD%3E%3CTD%20width%3D%22118px%22%3EIndustry%3C%2FTD%3E%3CTD%20width%3D%2268.6667px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268.6667px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268.6667px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22107.333px%22%3EHoward%20Kogan%3C%2FTD%3E%3CTD%20width%3D%2299.3333px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2294.6667px%22%3EHoward%20Kogan%3C%2FTD%3E%3CTD%20width%3D%22248px%22%3E%3CA%20href%3D%22mailto%3Asecret%40underscore.vc%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Esecret%40underscore.vc%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%22145.333px%22%3Enot%20valid%3C%2FTD%3E%3CTD%20width%3D%2295.3333px%22%3EHoward%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3EKogan%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3EHoward%20Kogan%3C%2FTD%3E%3CTD%20width%3D%22353.333px%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fin%2Fhkogan%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.linkedin.com%2Fin%2Fhkogan%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%2298.6667px%22%3ECore%20Member%3C%2FTD%3E%3CTD%20width%3D%22116.667px%22%3EBoston.%20Massachusetts.%20United%20States%3C%2FTD%3E%3CTD%20width%3D%22109.333px%22%3E2021-04-26%2013%3A04%3A10%3C%2FTD%3E%3CTD%20width%3D%22147.333px%22%3EUnderscore%20VC%3C%2FTD%3E%3CTD%20width%3D%22283.333px%22%3E%3CA%20href%3D%22http%3A%2F%2Fwww.underscore.vc%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttp%3A%2F%2Fwww.underscore.vc%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%22355.333px%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fcompany%2F10791786%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.linkedin.com%2Fcompany%2F10791786%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%2278px%22%3E11-50%3C%2FTD%3E%3CTD%20width%3D%2275.3333px%22%3EUnited%20States%3C%2FTD%3E%3CTD%20width%3D%22116.667px%22%3EBoston.%20Massachusetts.%20United%20States%3C%2FTD%3E%3CTD%20width%3D%2295.3333px%22%3EMA%3C%2FTD%3E%3CTD%20width%3D%2282px%22%3EBoston%3C%2FTD%3E%3CTD%20width%3D%22186.667px%22%3EVenture%20Capital%20%26amp%3B%20Private%20Equity%3C%2FTD%3E%3CTD%20width%3D%2268.6667px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268.6667px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22107.333px%22%3EPat%20Flynn%3C%2FTD%3E%3CTD%20width%3D%2299.3333px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2294.6667px%22%3ETodd%20Gettelfinger%3C%2FTD%3E%3CTD%20width%3D%22248px%22%3E%3CA%20href%3D%22mailto%3Asecret%40OrbitMedia.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Esecret%40OrbitMedia.com%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%22145.333px%22%3Eunknown%3C%2FTD%3E%3CTD%20width%3D%2295.3333px%22%3ETodd%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3EGettelfinger%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3ETodd%20Gettelfinger%3C%2FTD%3E%3CTD%20width%3D%22353.333px%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fin%2Ftoddgettelfinger%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.linkedin.com%2Fin%2Ftoddgettelfinger%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%2298.6667px%22%3EChief%20Executive%20Officer%3C%2FTD%3E%3CTD%20width%3D%22116.667px%22%3EChicago.%20Illinois.%20United%20States%3C%2FTD%3E%3CTD%20width%3D%22109.333px%22%3E2021-04-26%2013%3A04%3A10%3C%2FTD%3E%3CTD%20width%3D%22147.333px%22%3EOrbit%20Media%20Studios.%20Inc.%3C%2FTD%3E%3CTD%20width%3D%22283.333px%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.orbitmedia.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.orbitmedia.com%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%22355.333px%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fcompany%2F218994%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.linkedin.com%2Fcompany%2F218994%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%2278px%22%3E11-50%3C%2FTD%3E%3CTD%20width%3D%2275.3333px%22%3EUnited%20States%3C%2FTD%3E%3CTD%20width%3D%22116.667px%22%3EChicago.%20Illinois.%20United%20States%3C%2FTD%3E%3CTD%20width%3D%2295.3333px%22%3EIL%3C%2FTD%3E%3CTD%20width%3D%2282px%22%3EChicago%3C%2FTD%3E%3CTD%20width%3D%22186.667px%22%3EMarketing%20and%20Advertising%3C%2FTD%3E%3CTD%20width%3D%2268.6667px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268.6667px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22107.333px%22%3ETodd%20Gettelfinger%3C%2FTD%3E%3CTD%20width%3D%2299.3333px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2294.6667px%22%3EKEVIN%20INDIG%3C%2FTD%3E%3CTD%20width%3D%22248px%22%3E%3CA%20href%3D%22mailto%3Asecret%40kevin-indig.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Esecret%40kevin-indig.com%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%22145.333px%22%3Enot%20valid%3C%2FTD%3E%3CTD%20width%3D%2295.3333px%22%3EKEVIN%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3EINDIG%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3EKEVIN%20INDIG%3C%2FTD%3E%3CTD%20width%3D%22353.333px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2298.6667px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22116.667px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22109.333px%22%3E2021-04-26%2013%3A04%3A10%3C%2FTD%3E%3CTD%20width%3D%22147.333px%22%3EKevin-indig%3C%2FTD%3E%3CTD%20width%3D%22283.333px%22%3E%3CA%20href%3D%22http%3A%2F%2Fkevin-indig.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttp%3A%2F%2Fkevin-indig.com%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%22355.333px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2278px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2275.3333px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22116.667px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295.3333px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2282px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22118px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268.6667px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268.6667px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268.6667px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22206.667px%22%3EMatthew%26nbsp%3BWoodward%3C%2FTD%3E%3CTD%20width%3D%2294.6667px%22%3EMatthew%20Woodward%3C%2FTD%3E%3CTD%20width%3D%22248px%22%3E%3CA%20href%3D%22mailto%3Asecret%40MatthewWoodward.co.uk%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Esecret%40MatthewWoodward.co.uk%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%22145.333px%22%3Evalid%3C%2FTD%3E%3CTD%20width%3D%2295.3333px%22%3EMatthew%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3EWoodward%3C%2FTD%3E%3CTD%20width%3D%22457.333px%22%3EMatthew%20Woodward%3C%2FTD%3E%3CTD%20width%3D%2298.6667px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22116.667px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22109.333px%22%3E2021-04-26%2013%3A04%3A10%3C%2FTD%3E%3CTD%20width%3D%22147.333px%22%3EMatthew%20Woodward%3C%2FTD%3E%3CTD%20width%3D%22283.333px%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.matthewwoodward.co.uk%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.matthewwoodward.co.uk%2F%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%22355.333px%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fcompany%2F11716818%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.linkedin.com%2Fcompany%2F11716818%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%2278px%22%3E1-10%3C%2FTD%3E%3CTD%20width%3D%2275.3333px%22%3EUnited%20Kingdom%3C%2FTD%3E%3CTD%20width%3D%22116.667px%22%3ETonbridge.%20United%20Kingdom%3C%2FTD%3E%3CTD%20width%3D%2295.3333px%22%3EEngland%3C%2FTD%3E%3CTD%20width%3D%2282px%22%3ETunbridge%20Wells%3C%2FTD%3E%3CTD%20width%3D%22118px%22%3EInternet%3C%2FTD%3E%3CTD%20width%3D%2268.6667px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268.6667px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268.6667px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%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%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%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%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%3CP%3EI%20want%20that%20it%20looks%20like%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%223225px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22107px%22%3E%3CSTRONG%3EColumn%20A%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2299px%22%3E%3CSTRONG%3EColumn%20B%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2294px%22%3E%3CSTRONG%3EColumn%20C%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%22248px%22%3E%3CSTRONG%3EColumn%20D%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%22145px%22%3E%3CSTRONG%3EColumn%20E%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3E%3CSTRONG%3EColumn%20F%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22353px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2298px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22116px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22109px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22147px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22283px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22355px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2278px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2275px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22116px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2282px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22118px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22107px%22%3EFull%20Name%3C%2FTD%3E%3CTD%20width%3D%2299px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2294px%22%3EFull%20Name%3C%2FTD%3E%3CTD%20width%3D%22248px%22%3EEmail%3C%2FTD%3E%3CTD%20width%3D%22145px%22%3EVerify%20Status%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3EFirst%20Name%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3ELast%20Name%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3EFull%20Name%3C%2FTD%3E%3CTD%20width%3D%22353px%22%3EUser%20Social%3C%2FTD%3E%3CTD%20width%3D%2298px%22%3EJob%20Position%3C%2FTD%3E%3CTD%20width%3D%22116px%22%3EProspect%20Location%3C%2FTD%3E%3CTD%20width%3D%22109px%22%3EAdd%20Date%3C%2FTD%3E%3CTD%20width%3D%22147px%22%3ECompany%20Name%3C%2FTD%3E%3CTD%20width%3D%22283px%22%3ECompany%20Url%3C%2FTD%3E%3CTD%20width%3D%22355px%22%3ECompany%20Social%3C%2FTD%3E%3CTD%20width%3D%2278px%22%3ECompany%20Size%3C%2FTD%3E%3CTD%20width%3D%2275px%22%3ECountry%3C%2FTD%3E%3CTD%20width%3D%22116px%22%3ELocation%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3EState%3C%2FTD%3E%3CTD%20width%3D%2282px%22%3ECity%3C%2FTD%3E%3CTD%20width%3D%22118px%22%3EIndustry%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22107px%22%3EHoward%20Kogan%3C%2FTD%3E%3CTD%20width%3D%2299px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2294px%22%3EHoward%20Kogan%3C%2FTD%3E%3CTD%20width%3D%22248px%22%3E%3CA%20href%3D%22mailto%3Asecret%40underscore.vc%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Esecret%40underscore.vc%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%22145px%22%3Enot%20valid%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3EHoward%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3EKogan%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3EHoward%20Kogan%3C%2FTD%3E%3CTD%20width%3D%22353px%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fin%2Fhkogan%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.linkedin.com%2Fin%2Fhkogan%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%2298px%22%3ECore%20Member%3C%2FTD%3E%3CTD%20width%3D%22116px%22%3EBoston.%20Massachusetts.%20United%20States%3C%2FTD%3E%3CTD%20width%3D%22109px%22%3E2021-04-26%2013%3A04%3A10%3C%2FTD%3E%3CTD%20width%3D%22147px%22%3EUnderscore%20VC%3C%2FTD%3E%3CTD%20width%3D%22283px%22%3E%3CA%20href%3D%22http%3A%2F%2Fwww.underscore.vc%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttp%3A%2F%2Fwww.underscore.vc%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%22355px%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fcompany%2F10791786%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.linkedin.com%2Fcompany%2F10791786%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%2278px%22%3E11-50%3C%2FTD%3E%3CTD%20width%3D%2275px%22%3EUnited%20States%3C%2FTD%3E%3CTD%20width%3D%22116px%22%3EBoston.%20Massachusetts.%20United%20States%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3EMA%3C%2FTD%3E%3CTD%20width%3D%2282px%22%3EBoston%3C%2FTD%3E%3CTD%20width%3D%22118px%22%3EVenture%20Capital%20%26amp%3B%20Private%20Equity%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22107px%22%3EPat%20Flynn%3C%2FTD%3E%3CTD%20width%3D%2299px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2294px%22%3EPat%20Flynn%3C%2FTD%3E%3CTD%20width%3D%22248px%22%3E%3CA%20href%3D%22mailto%3Asecret%40smartpassiveincome.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Esecret%40smartpassiveincome.com%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%22145px%22%3Evalid%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3EPat%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3EFlynn%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3EPat%20Flynn%3C%2FTD%3E%3CTD%20width%3D%22353px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2298px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22116px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22109px%22%3E2021-04-26%2013%3A04%3A10%3C%2FTD%3E%3CTD%20width%3D%22147px%22%3ESmartpassiveincome%3C%2FTD%3E%3CTD%20width%3D%22283px%22%3E%3CA%20href%3D%22http%3A%2F%2Fsmartpassiveincome.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttp%3A%2F%2Fsmartpassiveincome.com%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%22355px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2278px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2275px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22116px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2282px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22118px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22107px%22%3ETodd%20Gettelfinger%3C%2FTD%3E%3CTD%20width%3D%2299px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2294px%22%3ETodd%20Gettelfinger%3C%2FTD%3E%3CTD%20width%3D%22248px%22%3E%3CA%20href%3D%22mailto%3Asecret%40OrbitMedia.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Esecret%40OrbitMedia.com%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%22145px%22%3Eunknown%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3ETodd%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3EGettelfinger%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3ETodd%20Gettelfinger%3C%2FTD%3E%3CTD%20width%3D%22353px%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fin%2Ftoddgettelfinger%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.linkedin.com%2Fin%2Ftoddgettelfinger%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%2298px%22%3EChief%20Executive%20Officer%3C%2FTD%3E%3CTD%20width%3D%22116px%22%3EChicago.%20Illinois.%20United%20States%3C%2FTD%3E%3CTD%20width%3D%22109px%22%3E2021-04-26%2013%3A04%3A10%3C%2FTD%3E%3CTD%20width%3D%22147px%22%3EOrbit%20Media%20Studios.%20Inc.%3C%2FTD%3E%3CTD%20width%3D%22283px%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.orbitmedia.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.orbitmedia.com%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%22355px%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fcompany%2F218994%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.linkedin.com%2Fcompany%2F218994%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%2278px%22%3E11-50%3C%2FTD%3E%3CTD%20width%3D%2275px%22%3EUnited%20States%3C%2FTD%3E%3CTD%20width%3D%22116px%22%3EChicago.%20Illinois.%20United%20States%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3EIL%3C%2FTD%3E%3CTD%20width%3D%2282px%22%3EChicago%3C%2FTD%3E%3CTD%20width%3D%22118px%22%3EMarketing%20and%20Advertising%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22206px%22%3EMatthew%20Woodward%3C%2FTD%3E%3CTD%20width%3D%2294px%22%3EMatthew%20Woodward%3C%2FTD%3E%3CTD%20width%3D%22248px%22%3E%3CA%20href%3D%22mailto%3Asecret%40MatthewWoodward.co.uk%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Esecret%40MatthewWoodward.co.uk%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%22145px%22%3Evalid%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3EMatthew%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3EWoodward%3C%2FTD%3E%3CTD%20width%3D%22457px%22%3EMatthew%20Woodward%3C%2FTD%3E%3CTD%20width%3D%2298px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22116px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22109px%22%3E2021-04-26%2013%3A04%3A10%3C%2FTD%3E%3CTD%20width%3D%22147px%22%3EMatthew%20Woodward%3C%2FTD%3E%3CTD%20width%3D%22283px%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.matthewwoodward.co.uk%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.matthewwoodward.co.uk%2F%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%22355px%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fcompany%2F11716818%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.linkedin.com%2Fcompany%2F11716818%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%2278px%22%3E1-10%3C%2FTD%3E%3CTD%20width%3D%2275px%22%3EUnited%20Kingdom%3C%2FTD%3E%3CTD%20width%3D%22116px%22%3ETonbridge.%20United%20Kingdom%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3EEngland%3C%2FTD%3E%3CTD%20width%3D%2282px%22%3ETunbridge%20Wells%3C%2FTD%3E%3CTD%20width%3D%22118px%22%3EInternet%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22107px%22%3EMatthew%20Barby%3C%2FTD%3E%3CTD%20width%3D%2299px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2294px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22248px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22145px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22353px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2298px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22116px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22109px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22147px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22283px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22355px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2278px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2275px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22116px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2282px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22118px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22107px%22%3EMari%20Smith%3C%2FTD%3E%3CTD%20width%3D%2299px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2294px%22%3EMari%20Smith%3C%2FTD%3E%3CTD%20width%3D%22248px%22%3E%3CA%20href%3D%22mailto%3Asecret%40MariSmith.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Esecret%40MariSmith.com%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%22145px%22%3Evalid%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3EMari%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3ESmith%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3EMari%20Smith%3C%2FTD%3E%3CTD%20width%3D%22353px%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fin%2Fmarismith%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.linkedin.com%2Fin%2Fmarismith%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%2298px%22%3EKeynote%20Speaker%20%7C%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22116px%22%3ESan%20Diego.%20California.%20United%20States%3C%2FTD%3E%3CTD%20width%3D%22109px%22%3E2021-04-26%2013%3A04%3A10%3C%2FTD%3E%3CTD%20width%3D%22147px%22%3EMari%20Smith%20International.%20Inc.%3C%2FTD%3E%3CTD%20width%3D%22283px%22%3E%3CA%20href%3D%22http%3A%2F%2Fmarismith.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttp%3A%2F%2Fmarismith.com%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%22355px%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fcompany%2F2140371%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.linkedin.com%2Fcompany%2F2140371%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%2278px%22%3E11-50%3C%2FTD%3E%3CTD%20width%3D%2275px%22%3EUnited%20States%3C%2FTD%3E%3CTD%20width%3D%22116px%22%3ESan%20Diego.%20California.%20United%20States%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3ECalifornia%3C%2FTD%3E%3CTD%20width%3D%2282px%22%3ESan%20Diego%3C%2FTD%3E%3CTD%20width%3D%22118px%22%3EProfessional%20Training%20%26amp%3B%20Coaching%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22107px%22%3EKevin%20Indig%3C%2FTD%3E%3CTD%20width%3D%2299px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2294px%22%3EKEVIN%20INDIG%3C%2FTD%3E%3CTD%20width%3D%22248px%22%3E%3CA%20href%3D%22mailto%3Asecret%40kevin-indig.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Esecret%40kevin-indig.com%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%22145px%22%3Enot%20valid%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3EKEVIN%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3EINDIG%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3EKEVIN%20INDIG%3C%2FTD%3E%3CTD%20width%3D%22353px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2298px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22116px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22109px%22%3E2021-04-26%2013%3A04%3A10%3C%2FTD%3E%3CTD%20width%3D%22147px%22%3EKevin-indig%3C%2FTD%3E%3CTD%20width%3D%22283px%22%3E%3CA%20href%3D%22http%3A%2F%2Fkevin-indig.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttp%3A%2F%2Fkevin-indig.com%3C%2FA%3E%3C%2FTD%3E%3CTD%20width%3D%22355px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2278px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2275px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22116px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2282px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22118px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Full%20Name%20of%20a%20person%20in%20Column%20C%20%2B%20all%20extra%20Data%20is%20aligned%20with%20the%20Full%20Name%20in%20Column%20A.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20uploaded%20a%20sample%20excel%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhich%20formula%20would%20work%20here%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3ETorge%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2298105%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2299255%22%20slang%3D%22en-US%22%3ERe%3A%20Align%20duplicates%20from%20two%20columns%20to%20same%20rows%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2299255%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1024466%22%20target%3D%22_blank%22%3E%40troyyy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'd%20run%20this%20macro%3A%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-visual%22%3E%3CCODE%3ESub%20Shuffle()%0A%20%20%20%20Dim%20r%20As%20Long%0A%20%20%20%20Dim%20m%20As%20Long%0A%20%20%20%20Dim%20rng%20As%20Range%0A%20%20%20%20Application.ScreenUpdating%20%3D%20False%0A%20%20%20%20m%20%3D%20Range(%22A%22%20%26amp%3B%20Rows.Count).End(xlUp).Row%0A%20%20%20%20Range(%22C2%3AU%22%20%26amp%3B%20m).Insert%20Shift%3A%3DxlShiftDown%0A%20%20%20%20For%20r%20%3D%202%20To%20m%0A%20%20%20%20%20%20%20%20Set%20rng%20%3D%20Range(%22C%3AC%22).Find(What%3A%3DRange(%22A%22%20%26amp%3B%20r).Value%2C%20LookAt%3A%3DxlWhole)%0A%20%20%20%20%20%20%20%20If%20Not%20rng%20Is%20Nothing%20Then%0A%20%20%20%20%20%20%20%20%20%20%20%20rng.Resize(1%2C%2019).Cut%20Destination%3A%3DRange(%22C%22%20%26amp%3B%20r)%0A%20%20%20%20%20%20%20%20End%20If%0A%20%20%20%20Next%20r%0A%20%20%20%20Application.CutCopyMode%20%3D%20False%0A%20%20%20%20Application.ScreenUpdating%20%3D%20True%0AEnd%20Sub%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello,

 

I have the following situation:

 

I have data (Full Name, Column A) that needs to be aligned with other Data from Column C on (Full Name and beyond).

 

I did a very similar post recently. But the formula doesn't work in this case.

https://techcommunity.microsoft.com/t5/excel/align-duplicates-from-two-columns-to-same-rows-in-excel...

 

 

Column AColumn BColumn CColumn DColumn EColumn F                  
Full Name Full NameEmailVerify StatusFirst NameLast NameFull NameUser SocialJob PositionProspect LocationAdd DateCompany NameCompany UrlCompany SocialCompany SizeCountryLocationStateCityIndustry   
Howard Kogan Howard Kogansecret@underscore.vcnot validHowardKoganHoward Koganhttps://www.linkedin.com/in/hkoganCore MemberBoston. Massachusetts. United States2021-04-26 13:04:10Underscore VChttp://www.underscore.vchttps://www.linkedin.com/company/1079178611-50United StatesBoston. Massachusetts. United StatesMABostonVenture Capital & Private Equity  
Pat Flynn Todd Gettelfingersecret@OrbitMedia.comunknownToddGettelfingerTodd Gettelfingerhttps://www.linkedin.com/in/toddgettelfingerChief Executive OfficerChicago. Illinois. United States2021-04-26 13:04:10Orbit Media Studios. Inc.https://www.orbitmedia.comhttps://www.linkedin.com/company/21899411-50United StatesChicago. Illinois. United StatesILChicagoMarketing and Advertising  
Todd Gettelfinger KEVIN INDIGsecret@kevin-indig.comnot validKEVININDIGKEVIN INDIG   2021-04-26 13:04:10Kevin-indighttp://kevin-indig.com          
Matthew WoodwardMatthew Woodwardsecret@MatthewWoodward.co.ukvalidMatthewWoodwardMatthew Woodward  2021-04-26 13:04:10Matthew Woodwardhttps://www.matthewwoodward.co.uk/https://www.linkedin.com/company/117168181-10United KingdomTonbridge. United KingdomEnglandTunbridge WellsInternet   
                      
                      

 

I want that it looks like this:

 

Column AColumn BColumn CColumn DColumn EColumn F                  
Full Name Full NameEmailVerify StatusFirst NameLast NameFull NameUser SocialJob PositionProspect LocationAdd DateCompany NameCompany UrlCompany SocialCompany SizeCountryLocationStateCityIndustry   
Howard Kogan Howard Kogansecret@underscore.vcnot validHowardKoganHoward Koganhttps://www.linkedin.com/in/hkoganCore MemberBoston. Massachusetts. United States2021-04-26 13:04:10Underscore VChttp://www.underscore.vchttps://www.linkedin.com/company/1079178611-50United StatesBoston. Massachusetts. United StatesMABostonVenture Capital & Private Equity   
Pat Flynn Pat Flynnsecret@smartpassiveincome.comvalidPatFlynnPat Flynn   2021-04-26 13:04:10Smartpassiveincomehttp://smartpassiveincome.com          
Todd Gettelfinger Todd Gettelfingersecret@OrbitMedia.comunknownToddGettelfingerTodd Gettelfingerhttps://www.linkedin.com/in/toddgettelfingerChief Executive OfficerChicago. Illinois. United States2021-04-26 13:04:10Orbit Media Studios. Inc.https://www.orbitmedia.comhttps://www.linkedin.com/company/21899411-50United StatesChicago. Illinois. United StatesILChicagoMarketing and Advertising   
Matthew WoodwardMatthew Woodwardsecret@MatthewWoodward.co.ukvalidMatthewWoodwardMatthew Woodward  2021-04-26 13:04:10Matthew Woodwardhttps://www.matthewwoodward.co.uk/https://www.linkedin.com/company/117168181-10United KingdomTonbridge. United KingdomEnglandTunbridge WellsInternet   
Matthew Barby                       
Mari Smith Mari Smithsecret@MariSmith.comvalidMariSmithMari Smithhttps://www.linkedin.com/in/marismithKeynote Speaker | San Diego. California. United States2021-04-26 13:04:10Mari Smith International. Inc.http://marismith.comhttps://www.linkedin.com/company/214037111-50United StatesSan Diego. California. United StatesCaliforniaSan DiegoProfessional Training & Coaching   
Kevin Indig KEVIN INDIGsecret@kevin-indig.comnot validKEVININDIGKEVIN INDIG   2021-04-26 13:04:10Kevin-indighttp://kevin-indig.com          

 

The Full Name of a person in Column C + all extra Data is aligned with the Full Name in Column A.

 

I uploaded a sample excel file.

 

Which formula would work here?

 

Cheers

Torge

 

1 Reply

@troyyy 

I'd run this macro:

Sub Shuffle()
    Dim r As Long
    Dim m As Long
    Dim rng As Range
    Application.ScreenUpdating = False
    m = Range("A" & Rows.Count).End(xlUp).Row
    Range("C2:U" & m).Insert Shift:=xlShiftDown
    For r = 2 To m
        Set rng = Range("C:C").Find(What:=Range("A" & r).Value, LookAt:=xlWhole)
        If Not rng Is Nothing Then
            rng.Resize(1, 19).Cut Destination:=Range("C" & r)
        End If
    Next r
    Application.CutCopyMode = False
    Application.ScreenUpdating = True
End Sub