/* * These styles apply ONLY to the header and footer assets. */ * { padding: 0; margin: 0; box-sizing: border-box; } .footer { background: #023d2f; color: #555a62; font-size: 14px; line-height: 1.5; padding: 18px 0; } .footer-wrap { padding-left: 18px; padding-right: 18px; max-width: 1236px; margin: 0 auto; } .footer a { color: #0291db; } .footer a:hover { color: #0276b3; } .footer-row { display: flex; flex-wrap: wrap; justify-content: space-between; align-items: center; margin: -3px; } .footer-col { padding: 0 3px; } .footer-col-copyRight { justify-content: flex-end; margin: 20px 0 20px 0; color: #ffffff; } .footer-col-logo { justify-content: flex-start; } .footer-col-home-button { justify-content: flex-center; } .home-button{ background-color: #023d2f; padding: 5px 20px 5px 20px; border-style: solid; border-width: 1px; border-color:#ffffff; color:#ffffff; } .home-button a:link, a:visited{ color:#ffffff; text-decoration: none; } .footer-col-copyRight, .footer-col-logo { flex: 1; display: flex; } .logo { width: 120px; height: 28px; opacity: 0.6; } @media screen and (max-width: 768px) { .footer-row { display: block; } .footer-col { width: 100%; text-align: center; margin: 6px 0; } .footer-col:first-child { margin-top: 0; } .footer-col:last-child { margin-bottom: 0; } .footer-col-copyRight, .footer-col-logo { justify-content: center; } .logo { margin: 0 auto; } } /*# sourceMappingURL=styles.css.map */

Please Sign In or Register to join the Community to see more content!

Transpose by Group

Chris Parker

Chris Parker Alumni Posts: 9

March 2022 in Ask a Question

Here's a question: I've got this sample data set (attached). How would I split out each of the Given Names and still keep all of the Nicknames for each of those concatenated Given Names?

Names Common nicknames sample data.xlsx

1 ·

Featured Member

Congrats!

Categories

/* * These styles apply ONLY to the header and footer assets. */ * { padding: 0; margin: 0; box-sizing: border-box; } .footer { background: #023d2f; color: #555a62; font-size: 14px; line-height: 1.5; padding: 18px 0; } .footer-wrap { padding-left: 18px; padding-right: 18px; max-width: 1236px; margin: 0 auto; } .footer a { color: #0291db; } .footer a:hover { color: #0276b3; } .footer-row { display: flex; flex-wrap: wrap; justify-content: space-between; align-items: center; margin: -3px; } .footer-col { padding: 0 3px; } .footer-col-copyRight { justify-content: flex-end; margin: 20px 0 20px 0; color: #ffffff; } .footer-col-logo { justify-content: flex-start; } .footer-col-home-button { justify-content: flex-center; } .home-button{ background-color: #023d2f; padding: 5px 20px 5px 20px; border-style: solid; border-width: 1px; border-color:#ffffff; color:#ffffff; } .home-button a:link, a:visited{ color:#ffffff; text-decoration: none; } .footer-col-copyRight, .footer-col-logo { flex: 1; display: flex; } .logo { width: 120px; height: 28px; opacity: 0.6; } @media screen and (max-width: 768px) { .footer-row { display: block; } .footer-col { width: 100%; text-align: center; margin: 6px 0; } .footer-col:first-child { margin-top: 0; } .footer-col:last-child { margin-bottom: 0; } .footer-col-copyRight, .footer-col-logo { justify-content: center; } .logo { margin: 0 auto; } } /*# sourceMappingURL=styles.css.map */